CREATE TABLE [dbo].[Product_Instance]
(
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_PRODUCT_CODE] DEFAULT (''),
[INSTANCE_NAME] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_INSTANCE_NAME] DEFAULT (''),
[BEGIN_DATE_TIME] [datetime] NULL,
[END_DATE_TIME] [datetime] NULL,
[COMPANY] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_COMPANY] DEFAULT (''),
[ADDRESS_1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_ADDRESS_1] DEFAULT (''),
[ADDRESS_2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_ADDRESS_2] DEFAULT (''),
[CITY] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_CITY] DEFAULT (''),
[STATE_PROVINCE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_STATE_PROVINCE] DEFAULT (''),
[ZIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_ZIP] DEFAULT (''),
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_COUNTRY] DEFAULT (''),
[NOTES] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_NOTES] DEFAULT (''),
[PROVIDER] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_PROVIDER] DEFAULT (''),
[INSTRUCTOR] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_INSTRUCTOR] DEFAULT (''),
[PRIMARY_CONTACT] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_PRIMARY_CONTACT] DEFAULT (''),
[PHONE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_PHONE] DEFAULT (''),
[FAX] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_FAX] DEFAULT (''),
[TOLL_FREE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_TOLL_FREE] DEFAULT (''),
[ADDRESS_3] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Instance_ADDRESS_3] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Product_Instance] ADD CONSTRAINT [PK_Product_Instance] PRIMARY KEY NONCLUSTERED ([PRODUCT_CODE], [INSTANCE_NAME]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Product_Instance] TO [IMIS]
GRANT SELECT ON  [dbo].[Product_Instance] TO [IMIS]
GRANT INSERT ON  [dbo].[Product_Instance] TO [IMIS]
GRANT DELETE ON  [dbo].[Product_Instance] TO [IMIS]
GRANT UPDATE ON  [dbo].[Product_Instance] TO [IMIS]
GO